// sql语句
const sqlMap = {
    user: {
        add: 'insert into user(username, phone, password, createTime) values (?, ?, ?, ?)',
        query: 'select *,(select count(*) from user) as total from user where id like "%"?"%" and username like "%"?"%" and phone like "%"?"%" and createTime between ? and ? order by createTime desc limit ?,?',
        login: 'select * from user where username=? and password=?',
        update: 'update user set username=?, phone=?, password=? where id=?',
        delete: 'delete from user where id in(?)'
    }
}

module.exports = sqlMap
